R

Level: Advanced

N/A

2014 - (present)

SQL

Level: Advanced

N/A

N/A

Vega-Lite (in JavaScript)

Level: Intermediate

N/A

N/A

^{* See Programming Skills section on page 3 for a full breakdown of all areas.}

Data Scientist

The Financial Times (FT)

London, UK

Nov 2018 - (present)

^{Previous role: Data Analyst (up to Feb 2020)}

The FT’s Data Science team is responsible for creating and productionising statistical and machine learning models for use within the organisation. While at the FT, I have been involved in the following initiatives:

• I’ve been at the forefront of developing our Lifetime Value (LTV) modeling, where we estimate how likely each of our customers are to renew their subscriptions.
• As part of our product strategy I undertook a project to attribute value to our various product categories. This involved determining how much monetary value and engagement power is generated by each part of our digital real-estate.
• I have performed scenario modeling on a number of proposed product and commercial changes to determine their potential effect on advertising and subscription revenue.
• I’ve been involved in training other members of staff in how to use R.

Before moving to the Data Science team, I was a Data Analyst working as part of our Insights team, which is also part of our Customer Analytics department. During this time I was:

• The person responsible for all product-related analysis.
• In charge of administering all the FT’s A/B testing.

Analyst

ICBC Standard Bank (ICBCS)

London, UK

May 2018 - Jul 2018

The Client Referential Data (CRD) team is responsible for managing client static and reference data used across the bank. My responsibilities included:

• Capture and maintenance of client data and settlement instructions.
• Managing subscriptions from market data sources.
• Performing reconciliations between internal systems.

Specialist

Maitland Group

Cape Town, South Africa

Mar 2015 - Nov 2017

While at Maitland, I was part of the Instrument and Fund Setup team. My responsibilities included:

• Import and maintenance of client reference data.
  
• The import of financial data from market sources (Bloomberg, Reuters etc).
  
• Building integration between systems and applications.
  
• Provide analysis and output data for audit and compliance purposes, as well as for management reports.

R

Level: Advanced

N/A

2014 - (present)

I’ve been using R for many years now and so I think it’s worth providing a bit of detail on some of the skills I have gained.

SQL

Level: Advanced

N/A

2014 - (present)

I’ve been using SQL for many years now and am completely comfortable with all elements of the syntax. This includes advanced topics such as query optimisation. The dialect that I have worked with most is BigQuery’s standard syntax, but I have also used Redshift and MS SQL Server.

While at the FT, I have contributed to our own internal SQL style guide to help standardise good style practices across the business.

Vega-Lite (in JavaScript)

Level: Intermediate

N/A

2019 - (present)

I’ve created and published several charts using Vega-Lite. They can be viewed on my website under www.jameslairdsmith.com/charts/.

gs

Author and maintainer

N/A

Nov 2018 - (present)

A package to make recurring calendar events a little easier by providing a simple grammar for expressing them using R code. The package includes functions to:

• Represent all kinds of date elements found in the lubridate package: years, months, weeks, days, weekdays, quarters, semesters etc.
  
• Represent dates in terms of their relations to one another, such as the “third Friday of July” or the “last Thursday in August”.
  
• Specify ranges of dates, such as “after the first Monday in July” but “before the last weekday of August”.
  
• Compose the above elements together in arbitrarily complex patterns.